StudentAwardLoan

EntityType | Independent
Logical Entity Name | StudentAwardLoan
Default Table Name | FaLoan
Logical Only | NO
Owner | dbo
Definition |
Note |

StudentAwardLoan Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
Id |  | INTEGER | NO |
StudentAwardId |  | INTEGER | NO |
DirectLoanIdentifier |  | CHAR(21) | YES |
SchoolDirectLoanCode |  | CHAR(6) | YES |
borrowerssn |  | CHAR(16) | YES |
borrowerlastname |  | CHAR(16) | YES |
borrowerfirstname |  | CHAR(9) | YES |
borrowermi |  | CHAR(1) | YES |
borrowercity |  | CHAR(16) | YES |
borrowerstate |  | CHAR(2) | YES |
BorrowerPostalCode |  | CHAR(14) | YES |
BorrowerLocalStreetAddress |  | TEXT | YES |
borrowerlocalcity |  | CHAR(16) | YES |
borrowerlocalstate |  | CHAR(2) | YES |
BorrowerLocalPostalCode |  | CHAR(10) | YES |
BorrowerPhoneNumber |  | CHAR(16) | YES |
borrowerdriverlicensenumber |  | CHAR(20) | YES |
borrowerdriverlicensestate |  | CHAR(2) | YES |
BorrowerBirthDate |  | DATETIME | YES |
borrowercitizenstatus |  | CHAR(1) | YES |
BorrowerAlienIdentifier |  | CHAR(9) | YES |
borrowerdefaultonloans |  | CHAR(1) | YES |
borroweremployer |  | CHAR(30) | YES |
BorrowerEmployerStreetAddress |  | CHAR(35) | YES |
borroweremployercity |  | CHAR(20) | YES |
borroweremployerstate |  | CHAR(2) | YES |
BorrowerEmployerPostalCode |  | CHAR(10) | YES |
BorrowerEmployerPhoneNumber |  | CHAR(16) | YES |
BorrowerLengthAtEmployer |  | NUMERIC(18, 2) | YES |
loanamountapproved |  | MONEY(19, 4) | YES |
loanamountrequested |  | MONEY(19, 4) | YES |
OriginationBatchIdentifier |  | VARCHAR(30) | YES |
originationstatus |  | CHAR(1) | YES |
originationdate |  | DATETIME | YES |
OriginationLastExportedDate |  | DATETIME | YES |
acknowledgedate |  | DATETIME | YES |
unsubeligibilityflag |  | CHAR(1) | YES |
unsubeligibilityuptoheal |  | CHAR(1) | YES |
bookstatus |  | CHAR(1) | YES |
bookdate |  | DATETIME | YES |
PromNotePrintIndicator |  | CHAR(1) | YES |
PromNoteSignedByStudent |  | CHAR(1) | YES |
PromNoteSignedByBorrower |  | CHAR(1) | YES |
PromNoteReceivedSignedDate |  | DATETIME | YES |
PromNoteAlteredByBorrower |  | CHAR(1) | YES |
PromNoteStatus |  | CHAR(1) | YES |
PromNotePrintedDate |  | DATETIME | YES |
PromNoteSignedDate |  | DATETIME | YES |
PromNotePrintSequenceNumber |  | INTEGER | YES |
PromNoteAcceptedAmount |  | INTEGER | YES |
PromNoteAcceptedAmountDate |  | DATETIME | YES |
PromNoteDirectLoanIdentifier |  | CHAR(21) | YES |
PromNoteAcceptedSequenceNumber |  | INTEGER | YES |
PromNoteAcknowledgeBatchIdentifier |  | CHAR(23) | YES |
PromNoteAcknowledgeDate |  | DATETIME | YES |
IsPromNoteIncludedOnManifest |  | BIT | NO |
ManifestBatchIdentifier |  | CHAR(23) | YES |
PromNoteManifestDate |  | DATETIME | YES |
pluscreditdecisionstatus |  | CHAR(1) | YES |
pluscreditdecisiondate |  | DATETIME | YES |
studentssn |  | CHAR(11) | YES |
studentfirstname |  | CHAR(9) | YES |
studentlastname |  | CHAR(16) | YES |
studentmi |  | CHAR(1) | YES |
studentcitizenstatus |  | CHAR(1) | YES |
StudentAlienIdentifier |  | CHAR(9) | YES |
StudentBirthDate |  | DATETIME | YES |
studentyearincollege |  | CHAR(2) | YES |
studentdefaultonloans |  | CHAR(1) | YES |
addresschangedate |  | DATETIME | YES |
localaddresschangedate |  | DATETIME | YES |
ssnchangedate |  | DATETIME | YES |
BirthDateChangeDate |  | DATETIME | YES |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
AltBorrowerStudentLoanDebt |  | MONEY(19, 4) | YES |
borrowerInterestIndicator |  | CHAR(1) | YES |
BorrowerLegalResidenceState |  | CHAR(2) | YES |
BorrowerLegalResidenceStateDate |  | DATETIME | YES |
borrowerOutstandingLoans |  | CHAR(1) | YES |
borrowerReferenceCode |  | CHAR(1) | YES |
CommonLineApplicationStatus |  | CHAR(1) | YES |
CommonLineLoanIdentifier |  | CHAR(17) | YES |
DeferRequestCode |  | CHAR(1) | YES |
EFTAuthorization |  | CHAR(1) | YES |
CommonLineRecipientLendingInstitutionId |  | INTEGER | YES |
LoanAmountCertified |  | MONEY(19, 4) | YES |
ProcessingCode |  | CHAR(2) | YES |
PromNoteDeliveryCode |  | CHAR(1) | YES |
RecordTypeIndicatorCode |  | CHAR(1) | YES |
SerialLoanCode |  | CHAR(1) | YES |
StudentSignatureCode |  | CHAR(1) | YES |
DisclosurePrintedDate |  | DATETIME | YES |
OriginationFeePercentage |  | MONEY(19, 4) | NO |
IsDisclosurePrintedAtLoc |  | BIT | NO |
CommonLineApplicationStatusDate |  | DATETIME | YES |
CommonLineApplicationLoanPhase |  | CHAR(4) | YES |
CommonLineApplicationLoanPhaseDate |  | DATETIME | YES |
CommonLineLoanSequenceNumber |  | CHAR(2) | YES |
GuaranteeReductionCode |  | CHAR(2) | YES |
LoanAmountCertifiedDate |  | DATETIME | YES |
LoanAmountGuaranteed |  | MONEY(19, 4) | YES |
LoanGuaranteeDate |  | DATETIME | YES |
EmailAddress |  | VARCHAR(50) | YES |
InterestRebatePercentage |  | MONEY(19, 4) | YES |
MasterPromNoteIndicator |  | CHAR(1) | YES |
LastPaymentDate |  | DATETIME | YES |
DeliquentDate |  | DATETIME | YES |
ExpirationDate |  | DATETIME | YES |
GraceDays |  | NUMERIC(9, 0) | YES |
LoanStatusEffectiveDate |  | DATETIME | YES |
LoanStatusCodeId |  | INTEGER | YES |
LoanBalance |  | MONEY(19, 4) | YES |
LoanInterest |  | NUMERIC(9, 2) | YES |
NumberPayments |  | NUMERIC(9, 0) | YES |
PaymentAmount |  | MONEY(19, 4) | YES |
PreClaimsDate |  | DATETIME | YES |
RepaymentDate |  | DATETIME | YES |
MasterPromNoteType |  | CHAR(1) | YES |
OriginationRejectCodes |  | CHAR(75) | YES |
EndorserAmount |  | MONEY(19, 4) | NO |
BorrowerIdentifier |  | VARCHAR(44) | YES |
IsIdentifierChanged |  | BIT | NO |
PrintDisclosureCode |  | CHAR(1) | YES |
BorrowerStreetAddress |  | VARCHAR(2000) | YES |
DefaultDate |  | DATETIME | YES |
DefaultRateUsageCodeId |  | INTEGER | YES |
IsPreProfessionalCourseWork |  | BIT | NO |
MasterPromNoteExpirationDate |  | DATETIME | YES |
IsEntranceCounselingReceived |  | BIT | NO |
LoanCreateDate |  | DATETIME | YES |
ApplicationIdentifier |  | CHAR(10) | YES |
ApplicationCompleteDate |  | DATETIME | YES |
ApplicationLoanAmount |  | NUMERIC(11, 2) | YES |
CreditBalanceOption |  | CHAR(1) | YES |
CreditActionChoice |  | CHAR(1) | YES |
CreditAppealStatus |  | CHAR(1) | YES |
MaximumLoanIndicator |  | CHAR(1) | YES |
CreditDecisionExpirationDate |  | DATETIME | YES |
OriginalCreditDecisionStatus |  | CHAR(1) | YES |
IsDefermentOption |  | BIT | YES |
IsParentRejectedForPlus |  | BIT | NO |
SpecialProgramType |  | CHAR(1) | NO |

StudentAwardLoan Keys

Key Name | Key Type | Keys
FaLoan_OriginationBatchID_N_N_IDX | Inversion Entry | OriginationBatchIdentifier
FaLoan_faloanid_U_C_IDX | PrimaryKey | Id
FaLoan_FaStudentAidID_CLApplicationStatus_ProcessingCode_FaLoanID_U_N_IDX | Alternate Key | StudentAwardId, CommonLineApplicationStatus, ProcessingCode, Id
FaLoan_DirectLoanID_N_N_IDX | Inversion Entry | DirectLoanIdentifier
FaLoan_CommonLineLoanID_N_N_IDX | Inversion Entry | CommonLineLoanIdentifier
FaLoan_fastudentaidid_N_N_IDX | Inversion Entry | StudentAwardId
Nk_FaLoan_FaLoanId_FaStudentAidId_LoanAmoutCertified | Inversion Entry | Id, StudentAwardId, LoanAmountCertified
Nk_FaLoan_CLApplicationStatus_ProcessingCode_FaStudentAidID | Inversion Entry | CommonLineApplicationStatus, ProcessingCode, StudentAwardId

StudentAwardLoan Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
StudentAward | Non-Identifying | One To Zero or More |  |  |  | StudentAwardId | NO
DefaultRateUsageCode | Non-Identifying | Zero or One to Zero or More |  |  |  | DefaultRateUsageCodeId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
CommonlineResponse | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAwardLoanApplication | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaLoanCommonLineChangeSendLog | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAwardLoanPrintDisclosure | Non-Identifying | One To Zero or More |  |  |  |  | NO

StudentAwardLoan Check Constraints

Check Constraint Name | CheckConstraint

StudentAwardLoan Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentAwardLoan | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaLoan | NO |  |  |

StudentAwardLoan Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

StudentAwardLoan Data Movement Rules

Name | Type | Rule Text/Value